<%-- 
    Document   : jurnal
    Created on : Nov 8, 2012, 10:26:54 AM
    Author     : admin
--%>
<%@page import="org.omg.PortableInterceptor.SYSTEM_EXCEPTION"%>
<%@page import="java.util.ArrayList"%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<%
            bean.koneksi conn = new bean.koneksi();
            bean.Siswa siswa = new bean.Siswa();
%>
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        
        <script language=javascript> var rev = "fwd"; 
            function titlebar(val) { var msg  = "JURNAL NILAI | SMA HARAPAN BANGSA"; 
                var res = " "; var speed = 100; var pos = val;  
                msg = " "+msg+" "; var le = msg.length; 
                if(rev == "fwd"){  if(pos < le){  pos = pos+1;  
                        scroll = msg.substr(0,pos);  document.title = scroll;  
                        timer = window.setTimeout("titlebar("+pos+")",speed);  }  
                    else{  rev = "bwd";  timer = window.setTimeout("titlebar("+pos+")",speed);  } } 
                else{  if(pos > 0){  pos = pos-1;  
                        var ale = le-pos;  scrol = msg.substr(ale,le);  
                        document.title = scrol;  timer = window.setTimeout("titlebar("+pos+")",speed);  }  
                    else{  rev = "fwd";  timer = window.setTimeout("titlebar("+pos+")",speed);  } } }  titlebar(0); 
        </script>
    <link href="http://img98.imageshack.us/img98/9617/image3cr0.gif" rel='SHORTCUT ICON'/>    
    </head>
    <style type="text/css">
        #main{

            font-weight: bold;
            padding-left:0px;
            padding-right:0px;
            margin-top: 0px;
            margin-left:170px;
            margin-right:170px;
            margin-bottom:0px;
        }

        #menuhor{
            list-style-type: disc;
            margin: 0;
            padding: 0;

            float: left;
        }
        #menuhor li {
            margin: auto;
            padding: inherit;
            float: left;

        }
        
        #menuhor a {
            float: none;
            width: 150px;
            text-align: center;
            color: #FFF;
            text-decoration: none;
            padding: 2px;
            line-height: 2;
            margin-bottom: 3px;
        }
        #menuhor a:hover{
            background: yellow;
        }
        
        #tabel {
            font-family: Arial;
            font-size: 13px;
        }
        
        .txt_content03 {
            font-family: Tahoma;
            font-size: 11px;
            }
    </style>


        <body bgcolor="grey">
        
       <script language="javascript">
            function show_hari()
            {
                //membuat variabel bertipe array untuk nama hari
                var NamaHari = new Array("Minggu", "Senin", "Selasa", "Rabu", "Kamis", "Jumat",
                "Sabtu");
                //membuat variabel bertipe array untuk nama bulan
                var NamaBulan = new Array("Januari", "Februari", "Maret", "April", "Mei",
                "Juni", "Juli", "Agustus", "September", "Oktober", "November", "Desember");
                var sekarang = new Date();
                var HariIni = NamaHari[sekarang.getDay()];
                var BulanIni = NamaBulan[sekarang.getMonth()];
                var tglSekarang = sekarang.getDate();
                var TahunIni = sekarang.getFullYear();
                document.write(HariIni + ", " + tglSekarang + " " + BulanIni + " " + TahunIni);
            }
        </script>

        <div id="main">

            <img alt="cover" src="gambar/tes.jpg" width="1000" height="200">
            <br>
            </body>
             <div id="menuhor"style="position:absolute;right:7px;left:470px;top:170px;">
                 <a href="home.html"><m style="color:black;font-family:Tahoma;font-size:20px">  HOME </a></m>
                 <a href="daftar.jsp"><m style="color:black;font-family:Tahoma;font-size:20px">| PENDAFTARAN </a></m>
                 <a href="jurnal.jsp"><m style="color:black;font-family:Tahoma;font-size:20px">| JURNAL NILAI</a></m>           
                 <a href="tentang.jsp"><m style="color:black;font-family:Tahoma;font-size:20px">| TENTANG SEKOLAH</a></m>
             </div>
            
            <font style="font-family: Arial; color:white"><script>show_hari();</script>
            | <font id="demo"></font>
            <script>
            var myVar=setInterval(function(){myTimer()},1000);

            function myTimer()
            {
                var d=new Date();
                var t=d.toLocaleTimeString();
                document.getElementById("demo").innerHTML=t;
            }
            </script>
            
            <br><br>
            
             <H1><font color="blue">Daftar Jurnal Nilai</font></H1>
        <br>
        </body>
        <div id="java">
                
             <br><br>
                <fieldset>   
                    <center>
                        <div id="java"> 
                            <form name="form" action="jurnal2.jsp" method="POST"> 

                                <table style="color: black"> 

                                <table id="tabel" border="0">
                                    <tr>
                                    <br>
                                    <font color="white">Searching berdasarkan  NIS :</font>
                                    </tr>

                                    <tr><td > NIS :</td>
                                        <td>
                                            <input type="text" name="nis" value="" size="30">
                                        </td></tr>
                                    <br><br><br>
                                </table>

                                <td><input type="submit" value="SEARCH"/></td>
                            </form>
                        </div> </center>

                </fieldset> 
                               
                
                 <%


                    try {
                        String query2 = "select * from pendaftaran order by nem desc";
                        
                        java.sql.Statement statement = conn.getConnection().createStatement();
                        java.sql.ResultSet result2 = statement.executeQuery(query2);
                               %>

    <br><br><br>
    <CENTER>
    <table style="font-family: Arial; font-size: 14px;border-color: black "width="1000" border="">
        <tr>
            
            <th align="center"><font color="white">Nama</font></th>
            <th align="center"><font color="white">Alamat</font></th>
            <th align="center"><font color="white">Asal Sekolah</font></th>
            <th align="center"><font color="white">Tanggal Lahir</font></th>
            <th align="center"><font color="white">Jenis Kelamin</font></th>
            <th align="center"><font color="white">Agama</font></th>
            <th align="center"><font color="white">NIS</font></th>
            <th align="center"><font color="white">NEM</font></th>
            <th align="center"><font color="white">RANKING</font></th>
        </tr>
    <%
            while (result2.next()){
    %>
    <tr style="font-family: Arial; font-size: 14px;color: lightcyan">
        
        <td align="center"><% out.println(result2.getString("nama")); %></td>
        <td align="center"><% out.println(result2.getString("alamat")); %></td>
        <td align="center"><% out.println(result2.getString("asalsekolah")); %></td>
        <td align="center"><% out.println(result2.getString("tanggallahir")); %></td>
        <td align="center"><% out.println(result2.getString("jeniskelamin")); %></td>
        <td align="center"><% out.println(result2.getString("agama")); %></td>
        <td align="center"><% out.println(result2.getString("nis")); %></td>
        <td align="center"><% out.println(result2.getString("nem")); %></td>
        <td align="center"><% out.println(result2.getRow());%></td>
                        
         
                        </tr>
                       
                        <%
                                    
                                }
                                statement.close();
                            } catch (Exception ex) {
                                out.println("message: " + ex.getMessage());
                            }
                        %>

                    </table>
    </Center>
      
                        </fieldset>    
                        
        <br><br><br>
        <br><br><br>
        <br><br><br><br><center><img src="gambar/sw.gif"
                                 width="500" height="100">
                            <br><br><br>
                        </center>
                        
        <hr style="color: black;" size=" 1px" >
        <center>
        <div class="txt_content03"><b>PPDB-harsa.sch.id</b><br><br>
        PPDB Online SMA Harapan Bangsa<br>
        Jln. Bhayangkara 15 Sleman, Yogyakarta, Indonesia<br>
        Tel: (0274)345-276,65782 , Fax :(0274)345-276,65782<br>

        Email: HARSA.School@gmail.com
        <br><br>
        Support by : <br>
        <a href="http://www.usd.ac.id" target="_blank">Universitas Sanata Dharma</a>
        <br>
        <br>
        © <a href="home.html" target="_blank">PPDB-harsa.sch.id</a>

    </div>

                </html>